Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
RetailStoreID (FK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | FuelingPoint(AS_PNT_FUEL) |
FuelingTransactionID (FK) | A unique identifier for the fuelling transaction | ID_TRN_FUEL | Identity | integer | FuelingTransaction(EV_TR_FUEL) |
PrepayFuelingPointID (FK) | A unique identifier for the FuelingPoint at a particular retail store | ID_PNT_FUEL | Identity | integer | FuelingPoint(AS_PNT_FUEL) |
FuelSaleStatusCode | A status code denoting the mode of the Fuel Sale. Possible values are: Prepay: Where the FuelSaleLineItem happens before the FuellingTransaction PostPay: Where the FuelSaleLineItem happens after the Fuelling Transaction PrepayRefund: Where the FuelSaleLineItem happens after a Prepay FuelSaleLineItem and the matching FuellingTransaction did not use all of the money | SC_SLS_FUEL | Code2Status | char(2) | |